/*
 Navicat MySQL Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : 127.0.0.1:3306
 Source Schema         : composite

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 26/10/2021 16:52:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_material
-- ----------------------------
DROP TABLE IF EXISTS `t_material`;
CREATE TABLE `t_material` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `material_name` varchar(20) DEFAULT NULL COMMENT '素材名称',
  `classify_id` int(5) DEFAULT NULL COMMENT '素材所属类别id',
  `classify_name` varchar(20) DEFAULT NULL COMMENT '素材所属类别名称',
  `file_path` varchar(50) DEFAULT NULL COMMENT '素材文件路径',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_material
-- ----------------------------
BEGIN;
INSERT INTO `t_material` VALUES (1, '背景图1', 1, '背景', '/Users/liuyajun/pics/背景1.png');
INSERT INTO `t_material` VALUES (2, '背景图2', 1, '背景', '/Users/liuyajun/pics/背景2.png');
INSERT INTO `t_material` VALUES (3, '基础图形1', 2, '基础图形', '/Users/liuyajun/pics/基础模型.png');
INSERT INTO `t_material` VALUES (4, '眼镜1', 3, '眼镜', '/Users/liuyajun/pics/眼镜1.png');
INSERT INTO `t_material` VALUES (5, '眼镜2', 3, '眼镜', '/Users/liuyajun/pics/眼镜2.png');
INSERT INTO `t_material` VALUES (6, '眼镜3', 3, '眼镜', '/Users/liuyajun/pics/眼镜3.png');
INSERT INTO `t_material` VALUES (7, '衣服1', 4, '衣服', '/Users/liuyajun/pics/衣服1.png');
INSERT INTO `t_material` VALUES (8, '衣服2', 4, '衣服', '/Users/liuyajun/pics/衣服2.png');
INSERT INTO `t_material` VALUES (9, '衣服3', 4, '衣服', '/Users/liuyajun/pics/衣服3.png');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
